<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Application Costs</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>CapEx and OpEx Parameters</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;border:1pt solid #ADB2B5"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>CAPEX % INPUT (user defined)</staticValue></dataSource><style><CSS value="font-size:8pt;color:black"/></style></textItem></contents><style><CSS value="padding-left:25px;text-align:right;padding-right:10px;border:1pt solid #ADB2B5"/></style></tableCell><tableCell><contents><textBox parameter="sCapex" required="false" numbersOnly="true"><style><CSS value="width:40px;height:24px;direction:rtl"/></style><defaultSelections><defaultSimpleSelection>80</defaultSimpleSelection></defaultSelections></textBox></contents><style><CSS value="padding-left:5px;vertical-align:middle;text-align:left;border:1pt solid #ADB2B5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>OPEX % INPUT (user defined)</staticValue></dataSource><style><CSS value="font-size:8pt;color:black"/></style></textItem></contents><style><CSS value="padding-left:25px;text-align:right;padding-right:10px;border:1pt solid #ADB2B5"/></style></tableCell><tableCell><contents><textBox parameter="sOpex" required="false" numbersOnly="true"><style><CSS value="width:40px;height:24px;direction:rtl"/></style><defaultSelections><defaultSimpleSelection>20</defaultSimpleSelection></defaultSelections></textBox></contents><style><CSS value="padding-left:5px;vertical-align:middle;text-align:left;border:1pt solid #ADB2B5"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><promptButton type="reprompt">
			<contents><textItem><dataSource><staticValue>Refresh Table</staticValue></dataSource></textItem></contents>
			<style>
				<defaultStyles>
					<defaultStyle refStyle="bp"/>
				</defaultStyles>
			<CSS value="background-color:silver"/></style>
		</promptButton></contents><style><CSS value="padding-left:5px;vertical-align:bottom"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:150px;vertical-align:top;padding-top:15px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>CapEx and OpEx Cost Summary</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart1" refQuery="Report" depth="9">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																								<CSS value="font-size:8pt;color:gray"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																				</v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_bar barShape="box">
																							<v2_solidPalette>
																								<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																							<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="$###,###,###"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Capex Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="$###,###,###"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="OpEx Cost"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="$###,###,###"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="centered" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																					</v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							<v2_automaticRange/>
																						</v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																								<CSS value="font-size:8pt;color:gray"/><dataFormat><numberFormat pattern="$###,###,###"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:350px;height:150px;color:#454545;font-size:8pt"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					</style>
																				</v2_legend>
																			</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Application Cost Detail</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" refQuery="Report" rowsPerPage="500">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;border:1pt solid #ADB2B5"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold;vertical-align:bottom;border:1pt solid #ADB2B5"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1pt solid #ADB2B5"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Application"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold;vertical-align:bottom;border:1pt solid #ADB2B5"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Service Level"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1pt solid #ADB2B5"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Service Level"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Service Level"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold;vertical-align:bottom;border:1pt solid #ADB2B5"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="border:1pt solid #ADB2B5"/><dataFormat><numberFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold;vertical-align:bottom;border:1pt solid #ADB2B5"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="border:1pt solid #ADB2B5"/><dataFormat><numberFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold;vertical-align:bottom;border:1pt solid #ADB2B5"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used %"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="border:1pt solid #ADB2B5"/><dataFormat><percentFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used %"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold;vertical-align:bottom;border:1pt solid #ADB2B5"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="border:1pt solid #ADB2B5"/><dataFormat><currencyFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Cost"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold;width:80px;text-align:left;border:1pt solid #ADB2B5"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capex Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px;border:1pt solid #ADB2B5"/><dataFormat><currencyFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Capex Cost"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="color:#454545;font-weight:bold;width:80px;text-align:left;border:1pt solid #ADB2B5"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="OpEx Cost"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:80px;border:1pt solid #ADB2B5"/><dataFormat><currencyFormat decimalSize="0"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="OpEx Cost"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Application"><listFooter><listRows><listRow><rowCells><rowCell colSpan="2"><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="background-color:#E4E3E4;color:#454545;border:1pt solid #ADB2B5"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:#E4E3E4;color:#454545;border:1pt solid #ADB2B5"/><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Used (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:#E4E3E4;color:#454545;border:1pt solid #ADB2B5"/><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total Used %"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:#E4E3E4;color:#454545;border:1pt solid #ADB2B5"/><dataFormat><percentFormat/></dataFormat></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Total Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:#E4E3E4;color:#454545;border:1pt solid #ADB2B5"/><dataFormat><currencyFormat decimalSize="0"/></dataFormat></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Capex Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:#E4E3E4;color:#454545;border:1pt solid #ADB2B5"/><dataFormat><currencyFormat decimalSize="0"/></dataFormat></style></rowCell><rowCell colSpan="1"><contents><textItem><dataSource><dataItemValue refDataItem="Total(OpEx Cost)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:#E4E3E4;color:#454545;border:1pt solid #ADB2B5"/><dataFormat><currencyFormat decimalSize="0"/></dataFormat></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="Service Level"/></listGroups></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding:5px 10px 10px 10px;background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>5.6 Application Costs with CapEx and OpEx Offset</reportName><queries><query name="Report"><source><sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT
dwh_capacity.application_dimension.name as 'Application',
dwh_capacity.tier_dimension.name as 'Service Level',
dwh_capacity.tier_dimension.cost as 'Cost',
ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) as 'Allocated (GB)',
ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) as 'Used (GB)',

SUM(dwh_capacity.chargeback_fact.usedCapacityMB) / SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB) as 'Used %',

ROUND((SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024) * dwh_capacity.tier_dimension.cost,2) as 'Total Cost',

#prompt('sCapex', 'integer' ,'80')# as 'Capex%',
#prompt('sOpex', 'integer' ,'20')# as 'Opex%'


FROM dwh_capacity.chargeback_fact
JOIN dwh_capacity.application_dimension
ON dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
JOIN dwh_capacity.tier_dimension
ON dwh_capacity.tier_dimension.tk=dwh_capacity.chargeback_fact.tiertk
JOIN dwh_capacity.date_dimension
ON dwh_capacity.date_dimension.tk=dwh_capacity.chargeback_fact.datetk

WHERE dwh_capacity.date_dimension.fullDate &gt;= (SELECT MAX(dwh_capacity.date_dimension.fullDate) 
FROM dwh_capacity.date_dimension JOIN  dwh_capacity.chargeback_fact 
ON  dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk) - INTERVAL 0 DAY

GROUP BY dwh_capacity.application_dimension.name, dwh_capacity.tier_dimension.name


</sqlText>
		<mdProjectedItems><mdProjectedItem name="Application"/><mdProjectedItem name="Service Level"/><mdProjectedItem name="Cost"/><mdProjectedItem name="Allocated (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="Used %"/><mdProjectedItem name="Total Cost"/><mdProjectedItem name="Capex%"/><mdProjectedItem name="Opex%"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Application"><expression>[SQL1].[Application]</expression></dataItem><dataItem name="Service Level"><expression>[SQL1].[Service Level]</expression></dataItem><dataItem name="Cost"><expression>[SQL1].[Cost]</expression></dataItem><dataItem name="Allocated (GB)" aggregate="average"><expression>[SQL1].[Allocated (GB)]</expression></dataItem><dataItem name="Used (GB)" aggregate="average"><expression>[SQL1].[Used (GB)]</expression></dataItem><dataItem name="Used %" aggregate="average"><expression>[SQL1].[Used %]</expression></dataItem><dataItem name="Total Cost" aggregate="total"><expression>[SQL1].[Total Cost]</expression></dataItem><dataItem name="Capex%"><expression>[SQL1].[Capex%]</expression></dataItem><dataItem name="Opex%"><expression>[SQL1].[Opex%]</expression></dataItem><dataItem name="Capex Cost" label="CapEx Cost (New) = Total Cost * CapEx input"><expression>[Total Cost]*([Capex%]/100)</expression></dataItem><dataItem name="OpEx Cost" label="OpEx Cost (New) = Total Cost * OpEx input"><expression>[Total Cost]*([Opex%]/100)</expression></dataItem><dataItem name="Total Used %" aggregate="average"><expression>total([Used (GB)] for [Application]) / total([Allocated (GB)] for [Application])</expression></dataItem><dataItemListSummary refDataItem="Allocated (GB)" aggregateMethod="total" name="Total(Allocated (GB))"/><dataItemListSummary refDataItem="Used (GB)" aggregateMethod="total" name="Total(Used (GB))"/><dataItemListSummary refDataItem="Used %" aggregateMethod="total" name="Total(Used %)"/><dataItemListSummary refDataItem="Total Cost" aggregateMethod="total" name="Total(Total Cost)"/><dataItemListSummary refDataItem="Capex Cost" aggregateMethod="total" name="Total(Capex Cost)"/><dataItemListSummary refDataItem="OpEx Cost" aggregateMethod="total" name="Total(OpEx Cost)"/></selection></query></queries></report>